MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Integrated Solution / Invoices (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 215KB | 1,125 lines

HBAM2016AUG95 Pro 3.0 ~~~~~~ HBAM3016AUG95@ 27a This Yearb 10/15/95...10/21/95 I'll perform the find 1a Last Week Pro 3.0F! Pro 3.0J t US Letter A4 Letter US Legal International Fanfold Computer Paper Envelope (#10) els^23456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 12345M% Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12/5/95 CANCEL FIND REQUEST CARRIER CONTACT ID CREATED BY Report Menu Invoice Entry Invoice Entry Help Shipping Entry Find Invoice Summary by Day Summary by Week Summary by Month View as List Summary by Year Print Invoice Report MenuB CREDIT CARD NUMBER CREDIT CARD TYPE DATE MODIFIED DATE SHIPPED DAY OF INVOICE DATE GRAND TOTAL INVOICE DATE INVOICE ID MODIFIED BY MONTH OF INVOICE DATE PAYMENT AMOUNT PAYMENT METHOD PAYMENT TERMS REPORT NAME SEARCH PERIOD SEARCH PERIOD REPORT SHIP ADDRESS SHIP CITY SHIP COMPANY SHIP FIRST NAME SHIP LAST NAME SHIP STATE SHIP THIS INVOICE SHIP TITLE SHIP ZIP SHIPPING COST SHIPPING PRIORITY SHIPPING WEIGHT SUB TOTAL TAX RATE TAX RATE OPTION TOTAL INVOICE TOTAL RECORDS TOTAL TAX TRACKING NUMBER WEEK OF YEAR YEAR OF INVOICE DATE Invoice DateB Date ModifiedB Created byB Modified byB Invoice IDB Contact IDB Payment TermsB A Sub TotalB Tax RateB Tax Rate OptionB Grand TotalB Shipping CostB Shipping WeightB Shipping PriorityB Tracking NumberB Credit Card NumberB Credit Card TypeB XSThe customer has paid by using a Credit Card. You must enter the Credit Card type. = "Credit Card" Credit Card Date ShippedB CarrierB Ship TitleB "Yes") "" ) Ship First NameB "Yes") "" ) Ship Last NameB "Yes") "" ) Ship AddressB "Yes") "" ) A Ship CityB "Yes") "" ) Ship StateB "Yes") "" ) Ship ZipB "Yes") "" ) Ship CompanyB "Yes") "" ) Payment MethodB XSThe customer has paid by using a Credit Card. You must enter the Credit Card type. = "Credit Card" Credit Card Payment AmountB X:You must enter a Cash Value into the Payment Amount field. = "Cash" Total RecordsB Year of Invoice DateB Month of Invoice DateB Search PeriodB Search Period ReportB Day of Invoice DateB Total InvoiceB 'A Total TaxB Week of YearB Report NameB Cancel Find RequestB Ship this InvoiceB .075^ I'll perform the findb 1/1/1995...12/31/1995j The Report Namek Cancelled Invoice EntryB Reports Main Entry View as Reports Main Entry View as Reports Invoice Report Line Items Reportsw Summarize by Dayx Summarize by Weeky Summarize by Month{4Creating reports is quite easy and requires 3 steps:| 3. Select the report below.} Find Your Own~/There are currently << ABBO>> Invoice(s) found. B1. Find the Invoices that you would like to create a report with. Your Own Report D:Select the correct search request or Find Your Own Records Summarize by Year 2. Name the report. Invoice Entry HelpB Invoice Data Entry Main Entry Invoice Data Entry Main Entry View as Reports Invoice Print Invoice Invoice Purchased by Street Address City~ State ZIP Code Company Name Invoice Number Product ID Description Quantity Price Extended Price Title First Credit Card Number Credit Card Type p Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier wwwwww Invoice Date Shipping EntryB Main Entry View as Reports Customer Print Invoice Invoice uest for the customer who is Invoice Data Entry Purchased by Street Address State ZIP Code Company Name Invoice Number Title First Credit Card Number Credit Card Type Product ID Description Quantity Price Extended Price Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier wwwwww A0Click to open database files and set preferences pe Click to A)Click to enter information for an invoice A<Click to see a list of the invoices that are currently found A8Click to find an invoice record in the Invoices database A,Use this button to print the current invoice A=Click to choose a predefined print-out such as mailing labels Click to create an invoice for a customer in the Contacts file. After clicking this button, enter a find request for the customer who is purchasing a product and click Find. Select the customer you wish to invoice, click Continue, and complete the invoice A.Click to enter shipment destination and method list of actions taken with t Click to return to data entry Find InvoiceB Shipping Details Main Entry View as Reports Contact Invoice Invoice Data Entry Title First Address State ZIP Code Company Name Weight Shipping Priority Tracking Number Date Shipped Carrier Shipping Address Purchased by Street Address State ZIP Code Company Name Invoice Number Title First Credit Card Number Credit Card Type Product ID Description Quantity Price Extended Price Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier wwwwww Carrier Information Ship this invoice Summary by DayB Find an Invoice Main Entry View as Reports Invoice Invoice Data Entryr Title Firstx Address State ZIP Code Busines Title Company Name Cancel Purchased by Street Address State ZIP Code Company Name Invoice Number Title First Credit Card Number Credit Card Type Product ID Description Quantity Price Extended Price Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier wwwwww Invoice Invoice Date Invoice Date Summary by WeekB Summary Report by Dayk Printed //l Printed by << AFAAABADABAB>>m Page ##n Search Range: << ABCC>>z Invoice Totals| Tax Totals} << ABCK>> Summary by MonthB Summary Report by Weekh Printed //i Printed by << AFAAABADABAB>>j Page ##k Search Range: << ABCC>>w Invoice Totalsx Tax Totalsy << ABCK>> View as ListB Summary Report by Monthh Printed //i Printed by << AFAAABADABAB>>j Page ##k Search Range: << ABCC>>t Invoice Totalsu Tax Totalsw << ABCK>> Summary by YearB g(Invoice List - Select an invoice to edit Main Entry g(Invoice List - Select an invoice to edit Main Entry CREDIT CARD NUMBER alisA LISTA View as Reports Invoice First Namev Last Namew Company Namex Invoice ID Print InvoiceB Summary Report by Yearh Printed //i Printed by << AFAAABADABAB>>j Page ##l Search Range: << ABCC>>u Invoice Totalsv Tax Totals ABCK>> 11/21/95B 11/28/95C Michael St. LorantD Keith ProctorE .0825L 5.56M 3 lbsN OvernightR 11/21/95S DennisV SmithW 88 Liberty St.X GrotonY 12345[ ACME Accessories\ Cash] 162.92_ 1995` 11/21/95B 11/27/95C Michael St. LorantD Keith ProctorE .0825L 9.95M 2 lbsN OvernightO 125-56-59-99R 11/21/95S Fed-ExT PamelaV 466 West Ave.X CheylanY 12345[ West End Corp.\ Cash] 50.54_ 1995` 11/21/95B 11/27/95C Michael St. LorantD Keith ProctorE .0825P 8956-5454-1234Q American Express\ Credit Card] 55.21_ 1995` 11/27/95B 11/27/95C Keith ProctorD Keith ProctorE .075_ 1995` 11/27/95B 11/27/95C Keith ProctorD Keith ProctorE .075_ 1995` Purchased byy Street Address} City~ State ZIP Code Company Name Invoice Number Product ID Description Quantity Price Extended Price Title First Credit Card Number Credit Card Type p Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Invoice Date AFAAABADABAC>> AFAAABADABAD>> AFAAABADABAE>>, << AFAAABADABAF>> << AFAAABADABAG>> Shipping Address Street Address State ZIP Code Company Name Title First Your Own Script Find Invoice Find Invoice from Report Find Invoice from Invoices Perform Find for Report Cancel Find Enter Shipping Details Create Invoice & Find Customer Create Invoice Sort First Name Sort Last Name Sort Company Name Go to Main Menu Go to Line Item Reports Go to Reports Go to Data Entry Preview or Print Summarize by Day Summarize by Week Summarize by Monthly Summarize by Yearly Print Invoice Cancel Find "Cancelled" Cancelled Enter Shipping Details Create Invoice & Find Customer Create Invoice Sort First Name Sort Last Name Sort Company Name Go to Main Menu Go to Reports Find Invoice from Report "Yes" Summarize by Week Go to Data Entry Perform Find for Report "I'll Perform the Find" I'll Perform the Find "I'll perform the find" I'll perform the findB Summarize by Monthly Summarize by Yearly Summarize by Day Preview or Print "Preview") PreviewGB9 "Print") PrintG Your Own Script ! = "Last Week" b)-1)-7) & "..." & b+ (7 - b)-7)) ! = "This Week" b)-1)) & "..." & b+ (7 - ! = "Last Month" b))) & "..." & b)) -1) ! = "This Month" b))) & "..." & b) + 1 b)) -1) ! = "Last Year" "1/1/" & ( )) -1) & "..." & "12/31/" & ( ))-1) ! = "This Year" "1/1/" & )) & "..." & "12/31/" & ! = "I'll Perform the Find" Last Week This Week Last Month This Month Last Year 1/1/ 12/31/ This Year 1/1/ 12/31/ I'll Perform the Find ) = 0 Cancel dN^ _PO OPENDOC There are no records that match your report's find request.H OKrform Fin Cancel,O\ Please select a find request. Print Invoice Find Invoice from Invoices + = "Cancelled" Cancelled ) = 1 Go to Line Item Reports Create your own script andB attatch it to a button. Helvetica Geneva Times JJJJ !BBBB "99BB #9999 $9911 %1111 &)))) '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! wwwwww ffffff 333333 """""" wwwwww ffffff UUUUUU DDDDDD 333333 wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD 333333 """""" #11#22122"3! "#""3"129 wwwwww ffffff UUUUUU DDDDDD 333333 """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVd fEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET DDCD4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! AD@D@ AD@D@ C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ UTdUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww wwxwwxw B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 wwwwww DDDDDD 333333 %US31 %US30 @@BA@ B220 DDDDDD DDDDDD DDDDDD B"#B0 B"#B"$ "2#B"#B"#@ 2$""#B"#@ "2#B"#@ 2$B"#@ UUUUUU wwwwww (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364, M4%"!!"560&)/<9;989;>3$ "03., PQ wwwwww wwwwww 44444 CCCCC 44444 CCCCC $42" QRPTH FPTHAQDaffy:Desktop Folder:Franz Project:FM Pro Solution:2-Enabled Layouts:Contacts.FP3 MSPCA NAMEA Contacts.FP3 RPTHA Contacts.FP3 ORPTH FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:2-Enabled Layouts:Line Items MSPCA NAMEA Line Items RPTHA Line Items ORPTH FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Main Menu.FP3 MSPCA NAMEA Main Menu.FP3 RPTHA ::3-More Changes:Main Menu.FP3 ORPTH FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Main Menu.FP3 MSPCA NAMEA Main Menu.FP3 RPTHA Main Menu.FP3 ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" (LIST LISTA 30 Day 60 Day 90 Day C.O.D. VDEFA( (LIST LISTA/Overnight Second Day Saturday Ground VDEFA( (LIST LISTA6American Express Diners Discover Card Master Card VDEFA( (LIST LISTA%Express Mail Fed-Ex Standard Mail VDEFA( (LIST LISTA Check Credit Card VDEFA( (LIST LISTA VDEFA( (LIST )NAME FPTHA)Daffy:Desktop Folder:x40:FAT:Contacts.FP3 MSPCA NAMEA Contacts.FP3 TRPTH FPTHATAPS Drive :Projects:Franz Project:Integrated Solution:28-More Changes:Line Items.FP3 APS Drive Line Items.FP3 FMP3FMP3 28-More Changes TAPS Drive :Projects:Franz Project:Integrated Solution:28-More Changes:Line Items.FP3 SCW-InfoMgmt Keith's Place APS Drive Keith Proctor MSPCA NAMEA Line Items.FP3 RPTHA Line Items.FP3 (LIST LISTA VDEFA( Payment Term ValuesB Shipping Priority ValuesC Credit Card ValuesD Carrier ValuesE Payment MethodF Personal Title ValuesG Search Period ValuesH Ship Invoice Values FMRLA FMRLA FMRLA CustomerB Line ItemsC Main Menu LISTAYLast Week This Week Last Month This Month Last Year This Year I'll Perform the Find VDEFA( Find Invoice Cancel Find "Cancelled" Cancelled Enter Shipping Details "Yes" APS Drive Line Items.FP3 FMP3FMP3 28-More Changes TAPS Drive :Projects:Franz Project:Integrated Solution:28-More Changes:Line Items.FP3 SCW-InfoMgmt Keith's Place APS Drive Keith Proctor